import pymysql
class query_test():
    def query_one(self):
        con=pymysql.Connect('localhost',port='3306',user='root',password='123456',database='Agileone',charset='utf8')

        cursor=con.cursor()

        cursor.execute("select * from notice where noticeid='2'")

        result=cursor.fetchall()
        print(result)
        print('123')

        print(456)
if __name__ == '__main__':
    te=query_test()
    te.query_one()